package com.lq.educationsystem.lqclasses.mapper;

import com.lq.educationsystem.common.vo.ClassesStudentPageVo;
import com.lq.educationsystem.lqclasses.entiy.ClassesStudentTb;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
* @author Administrator
* @description 针对表【classes_student_tb】的数据库操作Mapper
* @createDate 2024-04-17 21:02:46
* @Entity com.lq.educationsystem.lqclasses.entiy.ClassesStudentTb
*/
public interface ClassesStudentTbMapper {

    int deleteByPrimaryKey(Long id);

    int insert(ClassesStudentTb record);

    int insertSelective(ClassesStudentTb record);

    ClassesStudentTb selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(ClassesStudentTb record);

    int updateByPrimaryKey(ClassesStudentTb record);

    List<ClassesStudentTb> queryList(@Param("start") Integer start, @Param("pageSize") Integer pageSize, @Param("classesStudent") ClassesStudentTb classesStudent);

    /**
     * 统计总数
     * @param classesStudentTb
     * @return
     */

    int queryCount(@Param("classesStudent") ClassesStudentTb classesStudentTb);


    List<ClassesStudentTb> queryClassesStudenInfotByStudentId(@Param("classesStudentTb") ClassesStudentTb classesStudentTb);

    ClassesStudentTb queryClassesInfoByStudentId(@Param("studentId") Integer studentId);

    int queryCountByStudentId(@Param("classesStudentTb") ClassesStudentTb classesStudentTb);

    /**
     * 通过班级id查询班级内所有学生id
     * @param classesStudentTb
     * @param start
     * @param pageSize
     * @return
     */
    List<ClassesStudentTb> queryClassesStudentInfoListByClassesId(@Param("classesStudentTb") ClassesStudentTb classesStudentTb,@Param("start") int start,@Param("pageSize") Integer pageSize);


    /**+
     * 通过id查询
     * @param studentId
     * @return
     */

}
